﻿if exists (select * from dbo.sysobjects where name = 'sp_Users_Update')	drop procedure [dbo].[sp_Users_Update]Go CREATE PROCEDURE dbo.sp_Users_Update	@uID		int,	@dpID		int,	@psID		int,	@Code		nvarchar(50),	@User		nvarchar(150),	@Pass		nvarchar(300),	@Name		nvarchar(150),	@Date		datetime,	@Add		nvarchar(300),	@Tel		char(50),	@Level		nvarchar(100),	@Ord		int,	@Email		nvarchar(100),	@Admin		int,	@Img		nvarchar(100),	@CN		int,	@paId		int,	@canAccept		varchar(1000)AS	UPDATE [Users] SET [dpID] = @dpID, [psID] = @psID, [Code] = @Code, [User] = @User, [Pass] = @Pass, [Name] = @Name, [Date] = @Date, [Add] = @Add, [Tel] = @Tel, [Level] = @Level, [Ord] = @Ord, [Email] = @Email, [Admin] = @Admin, [Img] = @Img, [CN] = @CN, [paId] = @paId, [canAccept] = @canAccept	 WHERE uID = @uIDGo 